<?php require_once('../Connections/agriculture.php'); ?>
<?php
$colname_vvideoRecordset1 = "-1";
if (isset($_GET['id'])) {
  $colname_vvideoRecordset1 = (get_magic_quotes_gpc()) ? $_GET['id'] : addslashes($_GET['id']);
}
mysql_select_db($database_agriculture, $agriculture);
$query_vvideoRecordset1 = sprintf("SELECT * FROM video WHERE video_id = %s", $colname_vvideoRecordset1);
$vvideoRecordset1 = mysql_query($query_vvideoRecordset1, $agriculture) or die(mysql_error());
$row_vvideoRecordset1 = mysql_fetch_assoc($vvideoRecordset1);
$totalRows_vvideoRecordset1 = mysql_num_rows($vvideoRecordset1);
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>无标题文档</title>
</head>

<p><a href="admin.php">返回</a></p>
<p>&nbsp;</p>

<table border="1" cellpadding="0" cellspacing="0">
  <tr>
    <td>ID</td>
    <td>标题</td>
    <td>类型</td>
    <td>发布者</td>
    <td>发布时间</td>
    <td>作物</td>
    <td>时期</td>
    <td>信息</td>
  </tr>
  <?php do { ?>
  <tr>
    <td><?php echo $row_vvideoRecordset1['video_id']; ?></td>
    <td><?php echo $row_vvideoRecordset1['video_title']; ?></td>
    <td><?php echo $row_vvideoRecordset1['video_class']; ?></td>
    <td><?php echo $row_vvideoRecordset1['video_publisher']; ?></td>
    <td><?php echo $row_vvideoRecordset1['video_time']; ?></td>
    <td><?php echo $row_vvideoRecordset1['video_name']; ?></td>
    <td><?php echo $row_vvideoRecordset1['video_period']; ?></td>
    <td><?php echo $row_vvideoRecordset1['video_information']; ?></td>
  </tr></table>
<p>&nbsp;</p>
    <p>
<object type="application/x-shockwave-flash" width="500" height="400" 
       wmode="transparent data="flvplayer.swf?file=movies/holiday.flv">
       <param name="movie" value="flvplayer.swf?file=<?php echo $row_vvideoRecordset1['video_other']; ?>" />
       <param name="wmode" value="transparent" />
</object>
      <?php } while ($row_vvideoRecordset1 = mysql_fetch_assoc($vvideoRecordset1)); ?>
        </p>
    <p>&nbsp;</p>
<p>

</p>
<p>
</p>
</body>
</html>
<?php
mysql_free_result($vvideoRecordset1);
?>